SELECT col2 , LAG(col2) OVER ( PARTITION BY col3 ORDER BY col1 ) LAG_col2 FROM "fewRowsAllData.parquet"